SUPPORT / SAMPLES & SAS NOTES
Problem Note 54775: Optimization and aggregation might fail after you add threads for online optimization
 |  |  |  |  |
Optimization and aggregation might fail in the SAS® Revenue Optimization Suite with the following error in the MerchIntelGridSvr.log file:
2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: ERROR: TKTException code = 6 (Access violation) 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #4 0x00002b1f2061c82c in tkmi_exception_handler (thread=0x3482, ctxt=0x2b1f93c8be9c, code=TKTE_UnknownException) at /sas/dev/mva-f3ro52/di/src/tkmi_exception.c:88 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #5 0x00002b1f1806e196 in bktExcept () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #6 0x00002b1f1807119b in bkt_segv () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #7 0x00002b1f1806e764 in bkt_signal_handler () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #8 <signal handler called> 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #9 0x00002b1f20697e3a in odf_service_ppe_to_sp (odf_arg=0x0, mg_est=0x2b1f93c7efa0, ppe=0x2b1f9084e810) at /sas/dev/mva-f3ro52/di/src/odf_util.c:458 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #10 0x00002b1f2068b908 in odf_elasticity_compute (this=0x0, pgs=0x2b1f93c7efa0) at /sas/dev/mva-f3ro52/di/src/odf_elasticity.c:141 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #11 0x00002b1f20695c59 in odf_service_run_model_group (odf_arg=0x0, pgs=0x2b1f93c7efa0, like_for_new_item=0x2b1f9084e810, like_item_inactive=0xa, like_for_short_item=0x2b1f93c82ca0, like_store_inactive=0x2b20991fb340, process_like=0, fill_default=0, status_filter=1) at /sas/dev/mva-f3ro52/di/src/odf_run_model_group.c:230 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #12 0x00002b1f20683174 in odf_service_process (odf_arg=0x0, gp_to_process=0x2b1f93c7efa0, like_for_new_item=0x2b1f9084e810, like_item_inactive=0xa, like_for_short_item=0x2b1f93c82ca0, like_store_inactive=0x2b20991fb340, process_like=0, fill_default=0) at /sas/dev/mva-f3ro52/di/src/odf_service.c:1220 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #13 0x00002b1f20681fc0 in odf_service_run_unit (context=0x0) at /sas/dev/mva-f3ro52/di/src/odf_service.c:889 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #14 0x00002b1f2068198a in odf_service_run (this=0x0, odf_arg=0x2b1f93c7efa0) at /sas/dev/mva-f3ro52/di/src/odf_service.c:182 2014-12-03 17:07:00,458 [pool-10-thread-6] DEBUG - STDOUT: #15 0x00002b1f208df302 in rpp_call_odf_service (dim=0x2b1f2cd84dd0, rppManager=0x2b20839321b0, rpp=0x2b1f900e2ec0, plan_sk_list=0x2b1f93c85280 "191462") at /sas/dev/mva-f3ro52/dippr/src/rpp_mgr_process.c:2490 2014-12-03 17:07:00,459 [pool-10-thread-6] DEBUG - STDOUT: #16 0x00002b1f208b1b82 in rpp_manager_run (rpp_mgr=0x0, process_sk=-1815613536, request_type=-1870338032, plan_sk_list=0xa <Address 0xa out of bounds>, spot_count=-1815597920, recommended_plan_sk_list=0x2b20991fb340 "\320M\330,\037+", is_batch=1) at /sas/dev/mva-f3ro52/dippr/src/rpp_mgr_main.c:174 2014-12-03 17:07:00,459 [pool-10-thread-6] DEBUG - STDOUT: #17 0x00002b1f208976eb in rpp_service_opt_eval (context=0x2b1f2cd84dd0) at /sas/dev/mva-f3ro52/dippr/src/rpp_service.c:127 2014-12-03 17:07:00,459 [pool-10-thread-6] DEBUG - STDOUT: #18 0x00002b1f206086a8 in logic_fn (ctxt=0x2b1f2176c350, req=0x2b1f89ece460, thread=0x2b1f6a1948f0, cb=0x2b1f916977e8) at /sas/dev/mva-f3ro52/di/src/job_manager.c:1281 2014-12-03 17:07:00,459 [pool-10-thread-6] DEBUG - STDOUT: #19 0x00002b1f22041d0b in basicPuddleMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkepdl.so 2014-12-03 17:07:00,459 [pool-10-thread-6] DEBUG - STDOUT: #20 0x00002b1f1806c9a6 in sktMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2014-12-03 17:07:00,459 [pool-10-thread-6] DEBUG - STDOUT: #21 0x00002b1f1806dffb in bktMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2014-12-03 17:07:00,459 [pool-10-thread-6] DEBUG - STDOUT: #22 0x0000003743607851 in start_thread () from /lib64/libpthread.so.0 2014-12-03 17:07:00,459 [pool-10-thread-6] DEBUG - STDOUT: #23 0x00000037432e894d in clone () from /lib64/libc.so.6
This error is likely to occur if you have performed both of the following:
- Added multiple threads for online optimization by specifying values for max_io_threads and max_cpu_threads in the following parameter in server.xml:
- Mapped the TPR_only or Psychological Points vehicle categories to a promotion support.
<property name="com.sas.solutions.di.tkmiserver.captain.onlineopt.args" value="max_io_threads=YY;max_cpu_threads=XX;"/>
The workaround for this issue is to not specify multiple threads for online optimization in server.xml.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M3 |
| Linux for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M3 | ||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M3 |
| Linux for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M3 | ||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M3 |
| Linux for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M3 | ||